//
//  DataBaseHandle.h
//  UIhomework_14
//
//  Created by dllo on 16/1/9.
//  Copyright © 2016年 lanou3g. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>
#import "TitleModel.h"
#import "MovieModel.h"
#import "RegisterModel.h"
@interface DataBaseHandle : NSObject{
    
    sqlite3 *dbPoint;
}



+ (DataBaseHandle *)shareDataBaseHandle;

//打开数据
- (void)openDB;

//创建活动表格
- (void)createTable;

//插入活动数据
- (void)insertModel:(TitleModel *)model;

//查询活动数据
- (NSMutableArray *)selectTable;

//删除活动数据
- (void)deleteModel:(TitleModel *)model;



//创建电影表格
- (void)createMovieTable;

//插入电影数据
- (void)insertMovieModel:(MovieModel *)model;

//查询电影数据
- (NSMutableArray *)selectMovieTable;

//删除电影数据
- (void)deleteMovieModel:(MovieModel *)model;



//创建注册表格
- (void)createRegister;

//插入注册数据
- (void)insertRegister:(RegisterModel *)model;

//查询注册数据
- (NSMutableArray *)selectRegister;

@end
